﻿CREATE VIEW [acms].[UserSecurity_View]
AS 
	SELECT 
		Id,
		SiteId,
		UserName,
		FirstName,
		LastName,
		DateOfBirth,
		EmailAddress,
		Gender,
		Address1,
		Address2,
		Town,
		County,
		PostCode,
		MobileTel,
		Created,
		Password,
		Salt,
		VersionId
	FROM [Users]
	Where Deleted = 0
;